Following are the Steps to be followed for altering a Table :
  
1> From the "ONEi Configuration Manager" user interface Clicks
on "Tool > Database Wizard > Table Alteration" to alter table.
  
Following are the different ways of altering any table :
  
*  Adding column.
  
*  Modifying  Column.
  
Adding Column :
*****************
  
i> Select the required table to be altered from the Drop down List.
  
ii> Click on "Add New" button and a new column will be added to the
bottom of the existing columns.
  
iii> Enter the column name,data-type,width and Constraint in the
appropriate Fields.
  
iv> Click on "Commit" to confirm the addition and click on "Exit"
to return back to the OCM interface.
  
Modifying Column :
********************
  
i> Select the required table to be altered from the Drop down List.
  
ii> Select the column you want to delete by clicking on the specific
checkbox provided under the "Select" Column and press "Delete".The
selected column gets deleted permanently.
  
ii> Select a column you want to modify i.e. Changing of Data Type or
changing the Width, by clicking on the specific checkbox provided
under the "Select" Column and then press "Modify" button.
  
iii> On pressing "Modify" button the table gets modified and a message
comes that the table has been modified successfully.
  
iv> Click on "Exit" button to return to the OCM user interface.